<?php
$db_original["".$_POST["TBLPREFIX"]."blocks"]["b_id"]["details"] = "INT NOT NULL";
$db_original["".$_POST["TBLPREFIX"]."blocks"]["b_username"]["details"] = "VARCHAR(100)";
$db_original["".$_POST["TBLPREFIX"]."blocks"]["b_location"]["details"] = "VARCHAR(30)";
$db_original["".$_POST["TBLPREFIX"]."blocks"]["b_order"]["details"] = "INT";
$db_original["".$_POST["TBLPREFIX"]."blocks"]["b_name"]["details"] = "VARCHAR(255)";
$db_original["".$_POST["TBLPREFIX"]."blocks"]["b_config"]["details"] = "TEXT";

$db_original["".$_POST["TBLPREFIX"]."changes"]["ch_id"]["details"] = "INT(11) NOT NULL AUTO_INCREMENT";
$db_original["".$_POST["TBLPREFIX"]."changes"]["ch_cid"]["details"] = "INT(11) NOT NULL DEFAULT '0'";
$db_original["".$_POST["TBLPREFIX"]."changes"]["ch_gid"]["details"] = "VARCHAR(255) NOT NULL DEFAULT ''";
$db_original["".$_POST["TBLPREFIX"]."changes"]["ch_gedfile"]["details"] = "INT(11) NOT NULL DEFAULT '0'";
$db_original["".$_POST["TBLPREFIX"]."changes"]["ch_type"]["details"] = "VARCHAR(25) NOT NULL DEFAULT ''";
$db_original["".$_POST["TBLPREFIX"]."changes"]["ch_user"]["details"] = "VARCHAR(255) NOT NULL DEFAULT ''";
$db_original["".$_POST["TBLPREFIX"]."changes"]["ch_time"]["details"] = "INT(11) NOT NULL DEFAULT '0'";
$db_original["".$_POST["TBLPREFIX"]."changes"]["ch_fact"]["details"] = "VARCHAR(15) DEFAULT NULL";
$db_original["".$_POST["TBLPREFIX"]."changes"]["ch_old"]["details"] = "TEXT";
$db_original["".$_POST["TBLPREFIX"]."changes"]["ch_new"]["details"] = "TEXT";
$db_original["".$_POST["TBLPREFIX"]."changes"]["ch_delete"]["details"] = "TINYINT(1) NOT NULL DEFAULT '0'";
    
$db_original["".$_POST["TBLPREFIX"]."counters"]["c_id"]["details"] = "VARCHAR(120) NOT NULL DEFAULT ''";
$db_original["".$_POST["TBLPREFIX"]."counters"]["c_number"]["details"] = "INT(11) NOT NULL DEFAULT '0'";

$db_original["".$_POST["TBLPREFIX"]."dates"]["d_day"]["details"] = "INT";
$db_original["".$_POST["TBLPREFIX"]."dates"]["d_month"]["details"] = "VARCHAR(5)";
$db_original["".$_POST["TBLPREFIX"]."dates"]["d_year"]["details"] = "INT";
$db_original["".$_POST["TBLPREFIX"]."dates"]["d_fact"]["details"] = "VARCHAR(10)";
$db_original["".$_POST["TBLPREFIX"]."dates"]["d_gid"]["details"] = "VARCHAR(255)";
$db_original["".$_POST["TBLPREFIX"]."dates"]["d_file"]["details"] = "INT";
$db_original["".$_POST["TBLPREFIX"]."dates"]["d_type"]["details"] = "VARCHAR(13)";

$db_original["".$_POST["TBLPREFIX"]."eventcache"]["ge_order"]["details"] = "INT(11) NOT NULL AUTO_INCREMENT";
$db_original["".$_POST["TBLPREFIX"]."eventcache"]["ge_gedcom"]["details"] = "VARCHAR(64) NOT NULL";
$db_original["".$_POST["TBLPREFIX"]."eventcache"]["ge_cache"]["details"] = "VARCHAR(10) NOT NULL";
$db_original["".$_POST["TBLPREFIX"]."eventcache"]["ge_gid"]["details"] = "VARCHAR(10) NOT NULL";
$db_original["".$_POST["TBLPREFIX"]."eventcache"]["ge_isdead"]["details"] = "INT(2) NOT NULL DEFAULT '0'";
$db_original["".$_POST["TBLPREFIX"]."eventcache"]["ge_fact"]["details"] = "VARCHAR(16) NOT NULL";
$db_original["".$_POST["TBLPREFIX"]."eventcache"]["ge_factrec"]["details"] = "TEXT NOT NULL";
$db_original["".$_POST["TBLPREFIX"]."eventcache"]["ge_type"]["details"] = "VARCHAR(5) NOT NULL";
$db_original["".$_POST["TBLPREFIX"]."eventcache"]["ge_datestamp"]["details"] = "INT(11) NOT NULL DEFAULT '0'";
$db_original["".$_POST["TBLPREFIX"]."eventcache"]["ge_name"]["details"] = "VARCHAR(64) NOT NULL";
$db_original["".$_POST["TBLPREFIX"]."eventcache"]["ge_gender"]["details"] = "VARCHAR(2) NOT NULL";

$db_original["".$_POST["TBLPREFIX"]."families"]["f_id"]["details"] = "VARCHAR(255)";
$db_original["".$_POST["TBLPREFIX"]."families"]["f_file"]["details"] = "INT";
$db_original["".$_POST["TBLPREFIX"]."families"]["f_husb"]["details"] = "VARCHAR(255)";
$db_original["".$_POST["TBLPREFIX"]."families"]["f_wife"]["details"] = "VARCHAR(255)";
$db_original["".$_POST["TBLPREFIX"]."families"]["f_chil"]["details"] = "TEXT";
$db_original["".$_POST["TBLPREFIX"]."families"]["f_gedcom"]["details"] = "TEXT";
$db_original["".$_POST["TBLPREFIX"]."families"]["f_numchil"]["details"] = "INT";

$db_original["".$_POST["TBLPREFIX"]."favorites"]["fv_id"]["details"] = "INT NOT NULL";       
$db_original["".$_POST["TBLPREFIX"]."favorites"]["fv_username"]["details"] = "VARCHAR(30)";
$db_original["".$_POST["TBLPREFIX"]."favorites"]["fv_gid"]["details"] = "VARCHAR(10)";
$db_original["".$_POST["TBLPREFIX"]."favorites"]["fv_type"]["details"] = "VARCHAR(10)";
$db_original["".$_POST["TBLPREFIX"]."favorites"]["fv_file"]["details"] = "VARCHAR(100)";
$db_original["".$_POST["TBLPREFIX"]."favorites"]["fv_url"]["details"] = "VARCHAR(255)";
$db_original["".$_POST["TBLPREFIX"]."favorites"]["fv_title"]["details"] = "VARCHAR(255)";
$db_original["".$_POST["TBLPREFIX"]."favorites"]["fv_note"]["details"] = "TEXT";

$db_original["".$_POST["TBLPREFIX"]."gedcoms"]["g_gedcom"]["details"] = "VARCHAR(64) NOT NULL DEFAULT ''";
$db_original["".$_POST["TBLPREFIX"]."gedcoms"]["g_config"]["details"] = "VARCHAR(64)";
$db_original["".$_POST["TBLPREFIX"]."gedcoms"]["g_privacy"]["details"] = "VARCHAR(64)";
$db_original["".$_POST["TBLPREFIX"]."gedcoms"]["g_title"]["details"] = "VARCHAR(50)";
$db_original["".$_POST["TBLPREFIX"]."gedcoms"]["g_path"]["details"] = "VARCHAR(64)";
$db_original["".$_POST["TBLPREFIX"]."gedcoms"]["g_id"]["details"] = "INT(11) NOT NULL DEFAULT '0'";
$db_original["".$_POST["TBLPREFIX"]."gedcoms"]["g_commonsurnames"]["details"] = "TEXT";
$db_original["".$_POST["TBLPREFIX"]."gedcoms"]["g_isdefault"]["details"] = "VARCHAR(2)";

$db_original["".$_POST["TBLPREFIX"]."gedconf"]["gc_gedcom"]["details"] = "VARCHAR (64) NOT NULL default ''";
$db_original["".$_POST["TBLPREFIX"]."gedconf"]["gc_language"]["details"] = "varchar (64)";
$db_original["".$_POST["TBLPREFIX"]."gedconf"]["gc_calendar_format"]["details"] = "VARCHAR (21)";
$db_original["".$_POST["TBLPREFIX"]."gedconf"]["gc_display_jewish_thousands"]["details"] = "TINYINT(1)";
$db_original["".$_POST["TBLPREFIX"]."gedconf"]["gc_display_jewish_gereshayim"]["details"] = "TINYINT(1)";
$db_original["".$_POST["TBLPREFIX"]."gedconf"]["gc_jewish_ashkenaz_pronunciation"]["details"] = "TINYINT(1)";
$db_original["".$_POST["TBLPREFIX"]."gedconf"]["gc_use_rtl_functions"]["details"] = "TINYINT(1)";
$db_original["".$_POST["TBLPREFIX"]."gedconf"]["gc_character_set"]["details"] = "VARCHAR (6)";
$db_original["".$_POST["TBLPREFIX"]."gedconf"]["gc_enable_multi_language"]["details"] = "TINYINT(1)";
$db_original["".$_POST["TBLPREFIX"]."gedconf"]["gc_default_pedigree_generations"]["details"] = "INT (3)";
$db_original["".$_POST["TBLPREFIX"]."gedconf"]["gc_max_pedigree_generations"]["details"] = "INT (3)";
$db_original["".$_POST["TBLPREFIX"]."gedconf"]["gc_max_descendancy_generations"]["details"] = "INT (3)";
$db_original["".$_POST["TBLPREFIX"]."gedconf"]["gc_use_rin"]["details"] = "TINYINT(1)";
$db_original["".$_POST["TBLPREFIX"]."gedconf"]["gc_pedigree_root_id"]["details"] = "VARCHAR (10)";
$db_original["".$_POST["TBLPREFIX"]."gedconf"]["gc_gedcom_id_prefix"]["details"] = "VARCHAR (6)";
$db_original["".$_POST["TBLPREFIX"]."gedconf"]["gc_source_id_prefix"]["details"] = "VARCHAR (6)";
$db_original["".$_POST["TBLPREFIX"]."gedconf"]["gc_repo_id_prefix"]["details"] = "VARCHAR (6)";
$db_original["".$_POST["TBLPREFIX"]."gedconf"]["gc_fam_id_prefix"]["details"] = "VARCHAR (6)";
$db_original["".$_POST["TBLPREFIX"]."gedconf"]["gc_media_id_prefix"]["details"] = "VARCHAR (6)";
$db_original["".$_POST["TBLPREFIX"]."gedconf"]["gc_pedigree_full_details"]["details"] = "TINYINT(1)";
$db_original["".$_POST["TBLPREFIX"]."gedconf"]["gc_pedigree_layout"]["details"] = "TINYINT(1)";
$db_original["".$_POST["TBLPREFIX"]."gedconf"]["gc_show_empty_boxes"]["details"] = "TINYINT(1)";
$db_original["".$_POST["TBLPREFIX"]."gedconf"]["gc_zoom_boxes"]["details"] = "VARCHAR (10)";
$db_original["".$_POST["TBLPREFIX"]."gedconf"]["gc_link_icons"]["details"] = "VARCHAR (10)";
$db_original["".$_POST["TBLPREFIX"]."gedconf"]["gc_abbreviate_chart_labels"]["details"] = "TINYINT(1)";
$db_original["".$_POST["TBLPREFIX"]."gedconf"]["gc_show_parents_age"]["details"] = "TINYINT(1)";
$db_original["".$_POST["TBLPREFIX"]."gedconf"]["gc_hide_live_people"]["details"] = "TINYINT(1)";
$db_original["".$_POST["TBLPREFIX"]."gedconf"]["gc_require_authentication"]["details"] = "TINYINT(1)";
$db_original["".$_POST["TBLPREFIX"]."gedconf"]["gc_welcome_text_auth_mode"]["details"] = "INT (2)";
$db_original["".$_POST["TBLPREFIX"]."gedconf"]["gc_welcome_text_auth_mode_4"]["details"] = "TEXT";
$db_original["".$_POST["TBLPREFIX"]."gedconf"]["gc_welcome_text_cust_head"]["details"] = "TINYINT(1)";
$db_original["".$_POST["TBLPREFIX"]."gedconf"]["gc_check_child_dates"]["details"] = "TINYINT(1)";
$db_original["".$_POST["TBLPREFIX"]."gedconf"]["gc_show_gedcom_record"]["details"] = "TINYINT(1)";
$db_original["".$_POST["TBLPREFIX"]."gedconf"]["gc_allow_edit_gedcom"]["details"] = "TINYINT(1)";
$db_original["".$_POST["TBLPREFIX"]."gedconf"]["gc_postal_code"]["details"] = "TINYINT(1)";
$db_original["".$_POST["TBLPREFIX"]."gedconf"]["gc_alpha_index_lists"]["details"] = "TINYINT(1)";
$db_original["".$_POST["TBLPREFIX"]."gedconf"]["gc_name_from_gedcom"]["details"] = "TINYINT(1)";
$db_original["".$_POST["TBLPREFIX"]."gedconf"]["gc_show_married_names"]["details"] = "TINYINT(1)";
$db_original["".$_POST["TBLPREFIX"]."gedconf"]["gc_show_id_numbers"]["details"] = "TINYINT(1)";
$db_original["".$_POST["TBLPREFIX"]."gedconf"]["gc_show_fam_id_numbers"]["details"] = "TINYINT(1)";
$db_original["".$_POST["TBLPREFIX"]."gedconf"]["gc_show_pedigree_places"]["details"] = "TINYINT(1)";
$db_original["".$_POST["TBLPREFIX"]."gedconf"]["gc_multi_media"]["details"] = "TINYINT(1)";
$db_original["".$_POST["TBLPREFIX"]."gedconf"]["gc_media_external"]["details"] = "TINYINT(1)";
$db_original["".$_POST["TBLPREFIX"]."gedconf"]["gc_media_directory"]["details"] = "VARCHAR (64)";
$db_original["".$_POST["TBLPREFIX"]."gedconf"]["gc_media_directory_levels"]["details"] = "INT (2)";
$db_original["".$_POST["TBLPREFIX"]."gedconf"]["gc_show_highlight_images"]["details"] = "TINYINT(1)";
$db_original["".$_POST["TBLPREFIX"]."gedconf"]["gc_use_thumbs_main"]["details"] = "TINYINT(1)";
$db_original["".$_POST["TBLPREFIX"]."gedconf"]["gc_thumbnail_width"]["details"] = "INT (5)";
$db_original["".$_POST["TBLPREFIX"]."gedconf"]["gc_auto_generate_thumbs"]["details"] = "TINYINT(1)";
$db_original["".$_POST["TBLPREFIX"]."gedconf"]["gc_hide_gedcom_errors"]["details"] = "TINYINT(1)";
$db_original["".$_POST["TBLPREFIX"]."gedconf"]["gc_word_wrapped_notes"]["details"] = "TINYINT(1)";
$db_original["".$_POST["TBLPREFIX"]."gedconf"]["gc_gedcom_default_tab"]["details"] = "INT (2)";
$db_original["".$_POST["TBLPREFIX"]."gedconf"]["gc_show_context_help"]["details"] = "TINYINT(1)";
$db_original["".$_POST["TBLPREFIX"]."gedconf"]["gc_contact_email"]["details"] = "VARCHAR (64)";
$db_original["".$_POST["TBLPREFIX"]."gedconf"]["gc_contact_method"]["details"] = "VARCHAR (15)";
$db_original["".$_POST["TBLPREFIX"]."gedconf"]["gc_webmaster_email"]["details"] = "VARCHAR (64)";
$db_original["".$_POST["TBLPREFIX"]."gedconf"]["gc_support_method"]["details"] = "VARCHAR (15)";
$db_original["".$_POST["TBLPREFIX"]."gedconf"]["gc_home_site_url"]["details"] = "VARCHAR (64)";
$db_original["".$_POST["TBLPREFIX"]."gedconf"]["gc_home_site_text"]["details"] = "VARCHAR (64)";
$db_original["".$_POST["TBLPREFIX"]."gedconf"]["gc_favicon"]["details"] = "VARCHAR (64)";
$db_original["".$_POST["TBLPREFIX"]."gedconf"]["gc_theme_dir"]["details"] = "VARCHAR (64)";
$db_original["".$_POST["TBLPREFIX"]."gedconf"]["gc_allow_theme_dropdown"]["details"] = "TINYINT(1)";
$db_original["".$_POST["TBLPREFIX"]."gedconf"]["gc_show_stats"]["details"] = "TINYINT(1)";
$db_original["".$_POST["TBLPREFIX"]."gedconf"]["gc_show_counter"]["details"] = "TINYINT(1)";
$db_original["".$_POST["TBLPREFIX"]."gedconf"]["gc_days_to_show_limit"]["details"] = "INT (4)";
$db_original["".$_POST["TBLPREFIX"]."gedconf"]["gc_common_names_threshold"]["details"] = "INT (4)";
$db_original["".$_POST["TBLPREFIX"]."gedconf"]["gc_common_names_add"]["details"] = "TEXT";
$db_original["".$_POST["TBLPREFIX"]."gedconf"]["gc_common_names_remove"]["details"] = "TEXT";
$db_original["".$_POST["TBLPREFIX"]."gedconf"]["gc_meta_author"]["details"] = "VARCHAR (64)";
$db_original["".$_POST["TBLPREFIX"]."gedconf"]["gc_meta_publisher"]["details"] = "VARCHAR (64)";
$db_original["".$_POST["TBLPREFIX"]."gedconf"]["gc_meta_copyright"]["details"] = "VARCHAR (64)";
$db_original["".$_POST["TBLPREFIX"]."gedconf"]["gc_meta_description"]["details"] = "VARCHAR (64)";
$db_original["".$_POST["TBLPREFIX"]."gedconf"]["gc_meta_page_topic"]["details"] = "VARCHAR (64)";
$db_original["".$_POST["TBLPREFIX"]."gedconf"]["gc_meta_audience"]["details"] = "VARCHAR (64)";
$db_original["".$_POST["TBLPREFIX"]."gedconf"]["gc_meta_page_type"]["details"] = "VARCHAR (64)";
$db_original["".$_POST["TBLPREFIX"]."gedconf"]["gc_meta_robots"]["details"] = "VARCHAR (64)";
$db_original["".$_POST["TBLPREFIX"]."gedconf"]["gc_meta_revisit"]["details"] = "VARCHAR (64)";
$db_original["".$_POST["TBLPREFIX"]."gedconf"]["gc_meta_keywords"]["details"] = "VARCHAR (64)";
$db_original["".$_POST["TBLPREFIX"]."gedconf"]["gc_meta_title"]["details"] = "VARCHAR (64)";
$db_original["".$_POST["TBLPREFIX"]."gedconf"]["gc_meta_surname_keywords"]["details"] = "TINYINT(1)";
$db_original["".$_POST["TBLPREFIX"]."gedconf"]["gc_chart_box_tags"]["details"] = "VARCHAR (64)";
$db_original["".$_POST["TBLPREFIX"]."gedconf"]["gc_use_quick_update"]["details"] = "TINYINT(1)";
$db_original["".$_POST["TBLPREFIX"]."gedconf"]["gc_show_quick_resn"]["details"] = "TINYINT(1)";
$db_original["".$_POST["TBLPREFIX"]."gedconf"]["gc_quick_add_facts"]["details"] = "VARCHAR (255)";
$db_original["".$_POST["TBLPREFIX"]."gedconf"]["gc_quick_required_facts"]["details"] = "VARCHAR (255)";
$db_original["".$_POST["TBLPREFIX"]."gedconf"]["gc_quick_add_famfacts"]["details"] = "VARCHAR (255)";
$db_original["".$_POST["TBLPREFIX"]."gedconf"]["gc_quick_required_famfacts"]["details"] = "VARCHAR (255)";
$db_original["".$_POST["TBLPREFIX"]."gedconf"]["gc_show_lds_at_glance"]["details"] = "TINYINT(1)";
$db_original["".$_POST["TBLPREFIX"]."gedconf"]["gc_underline_name_quotes"]["details"] = "TINYINT(1)";
$db_original["".$_POST["TBLPREFIX"]."gedconf"]["gc_split_places"]["details"] = "TINYINT(1)";
$db_original["".$_POST["TBLPREFIX"]."gedconf"]["gc_show_relatives_events"]["details"] = "VARCHAR (255)";
$db_original["".$_POST["TBLPREFIX"]."gedconf"]["gc_expand_relatives_events"]["details"] = "TINYINT(1)";
$db_original["".$_POST["TBLPREFIX"]."gedconf"]["gc_edit_autoclose"]["details"] = "TINYINT(1)";
$db_original["".$_POST["TBLPREFIX"]."gedconf"]["gc_sour_facts_unique"]["details"] = "VARCHAR (255)";
$db_original["".$_POST["TBLPREFIX"]."gedconf"]["gc_sour_facts_add"]["details"] = "VARCHAR (255)";
$db_original["".$_POST["TBLPREFIX"]."gedconf"]["gc_repo_facts_unique"]["details"] = "VARCHAR (255)";
$db_original["".$_POST["TBLPREFIX"]."gedconf"]["gc_repo_facts_add"]["details"] = "VARCHAR (255)";
$db_original["".$_POST["TBLPREFIX"]."gedconf"]["gc_indi_facts_unique"]["details"] = "VARCHAR (255)";
$db_original["".$_POST["TBLPREFIX"]."gedconf"]["gc_indi_facts_add"]["details"] = "VARCHAR (255)";
$db_original["".$_POST["TBLPREFIX"]."gedconf"]["gc_fam_facts_unique"]["details"] = "VARCHAR (255)";
$db_original["".$_POST["TBLPREFIX"]."gedconf"]["gc_fam_facts_add"]["details"] = "VARCHAR (255)";
$db_original["".$_POST["TBLPREFIX"]."gedconf"]["gc_rss_format"]["details"] = "VARCHAR (10)";
$db_original["".$_POST["TBLPREFIX"]."gedconf"]["gc_time_limit"]["details"] = "INT (4)";
$db_original["".$_POST["TBLPREFIX"]."gedconf"]["gc_last_change_email"]["details"] = "INT (11) DEFAULT '0'";
$db_original["".$_POST["TBLPREFIX"]."gedconf"]["gc_last_upcoming"]["details"] = "INT (11) DEFAULT '0'";
$db_original["".$_POST["TBLPREFIX"]."gedconf"]["gc_last_today"]["details"] = "INT (11) DEFAULT '0'";
$db_original["".$_POST["TBLPREFIX"]."gedconf"]["gc_last_stats"]["details"] = "INT (11) DEFAULT '0'";

$db_original["".$_POST["TBLPREFIX"]."individual_child"]["ID"]["details"] = "INT(11) NOT NULL AUTO_INCREMENT";
$db_original["".$_POST["TBLPREFIX"]."individual_child"]["gedfile"]["details"] = "INT(11) NOT NULL DEFAULT '0'";
$db_original["".$_POST["TBLPREFIX"]."individual_child"]["pid"]["details"] = "VARCHAR(255) NOT NULL DEFAULT ''";
$db_original["".$_POST["TBLPREFIX"]."individual_child"]["family_id"]["details"] = "VARCHAR(255) DEFAULT NULL";

$db_original["".$_POST["TBLPREFIX"]."individual_spouse"]["ID"]["details"] = "INT(11) NOT NULL AUTO_INCREMENT";
$db_original["".$_POST["TBLPREFIX"]."individual_spouse"]["gedfile"]["details"] = "INT(11) NOT NULL DEFAULT '0'";
$db_original["".$_POST["TBLPREFIX"]."individual_spouse"]["pid"]["details"] = "VARCHAR(255) NOT NULL DEFAULT ''";
$db_original["".$_POST["TBLPREFIX"]."individual_spouse"]["family_id"]["details"] = "VARCHAR(255) DEFAULT NULL";

$db_original["".$_POST["TBLPREFIX"]."individuals"]["i_id"]["details"] = "VARCHAR(255)";
$db_original["".$_POST["TBLPREFIX"]."individuals"]["i_file"]["details"] = "INT";
$db_original["".$_POST["TBLPREFIX"]."individuals"]["i_rin"]["details"] = "VARCHAR(255)";
$db_original["".$_POST["TBLPREFIX"]."individuals"]["i_name"]["details"] = "VARCHAR(255)";
$db_original["".$_POST["TBLPREFIX"]."individuals"]["i_isdead"]["details"] = "INT DEFAULT 1";
$db_original["".$_POST["TBLPREFIX"]."individuals"]["i_gedcom"]["details"] = "TEXT";
$db_original["".$_POST["TBLPREFIX"]."individuals"]["i_letter"]["details"] = "VARCHAR(5)";
$db_original["".$_POST["TBLPREFIX"]."individuals"]["i_surname"]["details"] = "VARCHAR(100)";
$db_original["".$_POST["TBLPREFIX"]."individuals"]["i_snsoundex"]["details"] = "VARCHAR(255)";
$db_original["".$_POST["TBLPREFIX"]."individuals"]["i_sndmsoundex"]["details"] = "VARCHAR(255)";
$db_original["".$_POST["TBLPREFIX"]."individuals"]["i_fnsoundex"]["details"] = "VARCHAR(255)";
$db_original["".$_POST["TBLPREFIX"]."individuals"]["i_fndmsoundex"]["details"] = "VARCHAR(255)";
$db_original["".$_POST["TBLPREFIX"]."individuals"]["i_gender"]["details"] = "CHAR(1)";

$db_original["".$_POST["TBLPREFIX"]."language"]["lg_string"]["details"] = "VARCHAR(255) NOT NULL DEFAULT ''";
$db_original["".$_POST["TBLPREFIX"]."language"]["lg_english"]["details"] = "TEXT NOT NULL";
$db_original["".$_POST["TBLPREFIX"]."language"]["lg_hebrew"]["details"] = "TEXT NOT NULL";
$db_original["".$_POST["TBLPREFIX"]."language"]["lg_dutch"]["details"] = "TEXT NOT NULL";
$db_original["".$_POST["TBLPREFIX"]."language"]["lg_portuguese-br"]["details"] = "TEXT NOT NULL";
$db_original["".$_POST["TBLPREFIX"]."language"]["lg_last_update_date"]["details"] = "INT(11) NOT NULL DEFAULT '0'";
$db_original["".$_POST["TBLPREFIX"]."language"]["lg_last_update_by"]["details"] = "VARCHAR(255) NOT NULL DEFAULT ''";
$db_original["".$_POST["TBLPREFIX"]."language"]["lg_czech"]["details"] = "TEXT NOT NULL";
$db_original["".$_POST["TBLPREFIX"]."language"]["lg_german"]["details"] = "TEXT NOT NULL";
$db_original["".$_POST["TBLPREFIX"]."language"]["lg_spanish"]["details"] = "TEXT NOT NULL";
$db_original["".$_POST["TBLPREFIX"]."language"]["lg_french"]["details"] = "TEXT NOT NULL";
$db_original["".$_POST["TBLPREFIX"]."language"]["lg_italian"]["details"] = "TEXT NOT NULL";
$db_original["".$_POST["TBLPREFIX"]."language"]["lg_hungarian"]["details"] = "TEXT NOT NULL";
$db_original["".$_POST["TBLPREFIX"]."language"]["lg_norwegian"]["details"] = "TEXT NOT NULL";
$db_original["".$_POST["TBLPREFIX"]."language"]["lg_polish"]["details"] = "TEXT NOT NULL";
$db_original["".$_POST["TBLPREFIX"]."language"]["lg_finnish"]["details"] = "TEXT NOT NULL";
$db_original["".$_POST["TBLPREFIX"]."language"]["lg_swedish"]["details"] = "TEXT NOT NULL";
$db_original["".$_POST["TBLPREFIX"]."language"]["lg_turkish"]["details"] = "TEXT NOT NULL";
$db_original["".$_POST["TBLPREFIX"]."language"]["lg_chinese"]["details"] = "TEXT NOT NULL";
$db_original["".$_POST["TBLPREFIX"]."language"]["lg_russian"]["details"] = "TEXT NOT NULL";
$db_original["".$_POST["TBLPREFIX"]."language"]["lg_greek"]["details"] = "TEXT NOT NULL";
$db_original["".$_POST["TBLPREFIX"]."language"]["lg_arabic"]["details"] = "TEXT NOT NULL";
$db_original["".$_POST["TBLPREFIX"]."language"]["lg_lithuanian"]["details"] = "TEXT NOT NULL";
$db_original["".$_POST["TBLPREFIX"]."language"]["lg_danish"]["details"] = "TEXT NOT NULL";
$db_original["".$_POST["TBLPREFIX"]."language"]["lg_vietnamese"]["details"] = "TEXT NOT NULL"; 

$db_original["".$_POST["TBLPREFIX"]."language_help"]["lg_string"]["details"] = "VARCHAR(255) NOT NULL DEFAULT ''";
$db_original["".$_POST["TBLPREFIX"]."language_help"]["lg_english"]["details"] = "TEXT NOT NULL";
$db_original["".$_POST["TBLPREFIX"]."language_help"]["lg_hebrew"]["details"] = "TEXT NOT NULL";
$db_original["".$_POST["TBLPREFIX"]."language_help"]["lg_dutch"]["details"] = "TEXT NOT NULL";
$db_original["".$_POST["TBLPREFIX"]."language_help"]["lg_portuguese-br"]["details"] = "TEXT NOT NULL";
$db_original["".$_POST["TBLPREFIX"]."language_help"]["lg_last_update_date"]["details"] = "INT(11) NOT NULL DEFAULT '0'";
$db_original["".$_POST["TBLPREFIX"]."language_help"]["lg_last_update_by"]["details"] = "VARCHAR(255) NOT NULL DEFAULT ''";
$db_original["".$_POST["TBLPREFIX"]."language_help"]["lg_czech"]["details"] = "TEXT NOT NULL";
$db_original["".$_POST["TBLPREFIX"]."language_help"]["lg_german"]["details"] = "TEXT NOT NULL";
$db_original["".$_POST["TBLPREFIX"]."language_help"]["lg_spanish"]["details"] = "TEXT NOT NULL";
$db_original["".$_POST["TBLPREFIX"]."language_help"]["lg_french"]["details"] = "TEXT NOT NULL";
$db_original["".$_POST["TBLPREFIX"]."language_help"]["lg_italian"]["details"] = "TEXT NOT NULL";
$db_original["".$_POST["TBLPREFIX"]."language_help"]["lg_hungarian"]["details"] = "TEXT NOT NULL";
$db_original["".$_POST["TBLPREFIX"]."language_help"]["lg_norwegian"]["details"] = "TEXT NOT NULL";
$db_original["".$_POST["TBLPREFIX"]."language_help"]["lg_polish"]["details"] = "TEXT NOT NULL";
$db_original["".$_POST["TBLPREFIX"]."language_help"]["lg_finnish"]["details"] = "TEXT NOT NULL";
$db_original["".$_POST["TBLPREFIX"]."language_help"]["lg_swedish"]["details"] = "TEXT NOT NULL";
$db_original["".$_POST["TBLPREFIX"]."language_help"]["lg_turkish"]["details"] = "TEXT NOT NULL";
$db_original["".$_POST["TBLPREFIX"]."language_help"]["lg_chinese"]["details"] = "TEXT NOT NULL";
$db_original["".$_POST["TBLPREFIX"]."language_help"]["lg_russian"]["details"] = "TEXT NOT NULL";
$db_original["".$_POST["TBLPREFIX"]."language_help"]["lg_greek"]["details"] = "TEXT NOT NULL";
$db_original["".$_POST["TBLPREFIX"]."language_help"]["lg_arabic"]["details"] = "TEXT NOT NULL";
$db_original["".$_POST["TBLPREFIX"]."language_help"]["lg_lithuanian"]["details"] = "TEXT NOT NULL";
$db_original["".$_POST["TBLPREFIX"]."language_help"]["lg_danish"]["details"] = "TEXT NOT NULL";
$db_original["".$_POST["TBLPREFIX"]."language_help"]["lg_vietnamese"]["details"] = "TEXT NOT NULL"; 

$db_original["".$_POST["TBLPREFIX"]."log"]["l_type"]["details"] = "VARCHAR(2)";
$db_original["".$_POST["TBLPREFIX"]."log"]["l_category"]["details"] = "VARCHAR(2)";
$db_original["".$_POST["TBLPREFIX"]."log"]["l_timestamp"]["details"] = "VARCHAR(15)";
$db_original["".$_POST["TBLPREFIX"]."log"]["l_ip"]["details"] = "VARCHAR(15)";
$db_original["".$_POST["TBLPREFIX"]."log"]["l_user"]["details"] = "VARCHAR(30)";
$db_original["".$_POST["TBLPREFIX"]."log"]["l_text"]["details"] = "TEXT";
$db_original["".$_POST["TBLPREFIX"]."log"]["l_gedcom"]["details"] = "VARCHAR(30)";

$db_original["".$_POST["TBLPREFIX"]."media"]["m_id"]["details"] = "INT(11) AUTO_INCREMENT";
$db_original["".$_POST["TBLPREFIX"]."media"]["m_media"]["details"] = "VARCHAR(15)";
$db_original["".$_POST["TBLPREFIX"]."media"]["m_ext"]["details"] = "VARCHAR(6)";
$db_original["".$_POST["TBLPREFIX"]."media"]["m_titl"]["details"] = "VARCHAR(255)";
$db_original["".$_POST["TBLPREFIX"]."media"]["m_file"]["details"] = "VARCHAR(255)";  
$db_original["".$_POST["TBLPREFIX"]."media"]["m_gedfile"]["details"] = "INT(11)";
$db_original["".$_POST["TBLPREFIX"]."media"]["m_gedrec"]["details"] = "TEXT";

$db_original["".$_POST["TBLPREFIX"]."media_mapping"]["mm_id"]["details"] = "INT(11) AUTO_INCREMENT";
$db_original["".$_POST["TBLPREFIX"]."media_mapping"]["mm_media"]["details"] = "VARCHAR(15) NOT NULL DEFAULT ''";
$db_original["".$_POST["TBLPREFIX"]."media_mapping"]["mm_gid"]["details"] = "VARCHAR(15) NOT NULL DEFAULT ''";
$db_original["".$_POST["TBLPREFIX"]."media_mapping"]["mm_order"]["details"] = "INT(11) NOT NULL DEFAULT '0'";
$db_original["".$_POST["TBLPREFIX"]."media_mapping"]["mm_gedfile"]["details"] = "INT(11) DEFAULT NULL";  
$db_original["".$_POST["TBLPREFIX"]."media_mapping"]["mm_gedrec"]["details"] = "TEXT";

$db_original["".$_POST["TBLPREFIX"]."messages"]["m_id"]["details"] = "INT NOT NULL";
$db_original["".$_POST["TBLPREFIX"]."messages"]["m_from"]["details"] = "VARCHAR(255)";
$db_original["".$_POST["TBLPREFIX"]."messages"]["m_to"]["details"] = "VARCHAR(30)";
$db_original["".$_POST["TBLPREFIX"]."messages"]["m_subject"]["details"] = "VARCHAR(255)";
$db_original["".$_POST["TBLPREFIX"]."messages"]["m_body"]["details"] = "TEXT";
$db_original["".$_POST["TBLPREFIX"]."messages"]["m_created"]["details"] = "VARCHAR(255)";

$db_original["".$_POST["TBLPREFIX"]."names"]["n_gid"]["details"] = "VARCHAR(255)";
$db_original["".$_POST["TBLPREFIX"]."names"]["n_file"]["details"] = "INT";
$db_original["".$_POST["TBLPREFIX"]."names"]["n_name"]["details"] = "VARCHAR(255)";
$db_original["".$_POST["TBLPREFIX"]."names"]["n_letter"]["details"] = "VARCHAR(5)";
$db_original["".$_POST["TBLPREFIX"]."names"]["n_surname"]["details"] = "VARCHAR(100)";
$db_original["".$_POST["TBLPREFIX"]."names"]["n_type"]["details"] = "VARCHAR(10)";

$db_original["".$_POST["TBLPREFIX"]."news"]["n_id"]["details"] = "INT NOT NULL";
$db_original["".$_POST["TBLPREFIX"]."news"]["n_username"]["details"] = "VARCHAR(100)";
$db_original["".$_POST["TBLPREFIX"]."news"]["n_date"]["details"] = "INT";
$db_original["".$_POST["TBLPREFIX"]."news"]["n_title"]["details"] = "VARCHAR(255)";
$db_original["".$_POST["TBLPREFIX"]."news"]["n_text"]["details"] = "TEXT";

$db_original["".$_POST["TBLPREFIX"]."other"]["o_id"]["details"] = "VARCHAR(255)";
$db_original["".$_POST["TBLPREFIX"]."other"]["o_file"]["details"] = "INT";
$db_original["".$_POST["TBLPREFIX"]."other"]["o_type"]["details"] = "VARCHAR(20)";
$db_original["".$_POST["TBLPREFIX"]."other"]["o_gedcom"]["details"] = "TEXT";

$db_original["".$_POST["TBLPREFIX"]."pages"]["pag_id"]["details"] = "INT(11) NOT NULL AUTO_INCREMENT";
$db_original["".$_POST["TBLPREFIX"]."pages"]["pag_content"]["details"] = "LONGTEXT NOT NULL";
$db_original["".$_POST["TBLPREFIX"]."pages"]["pag_title"]["details"] = "VARCHAR(40) NOT NULL DEFAULT ''";

$db_original["".$_POST["TBLPREFIX"]."placelinks"]["pl_p_id"]["details"] = "INT";
$db_original["".$_POST["TBLPREFIX"]."placelinks"]["pl_gid"]["details"] = "VARCHAR(255)";
$db_original["".$_POST["TBLPREFIX"]."placelinks"]["pl_file"]["details"] = "INT";

$db_original["".$_POST["TBLPREFIX"]."places"]["p_id"]["details"] = "INT NOT NULL";
$db_original["".$_POST["TBLPREFIX"]."places"]["p_place"]["details"] = "VARCHAR(150)";
$db_original["".$_POST["TBLPREFIX"]."places"]["p_level"]["details"] = "INT";
$db_original["".$_POST["TBLPREFIX"]."places"]["p_parent_id"]["details"] = "INT";
$db_original["".$_POST["TBLPREFIX"]."places"]["p_file"]["details"] = "INT";

$db_original["".$_POST["TBLPREFIX"]."privacy"]["p_gedcom"]["details"] = "VARCHAR (64) NOT NULL default ''";
$db_original["".$_POST["TBLPREFIX"]."privacy"]["p_privacy_version"]["details"] = "VARCHAR (6)";
$db_original["".$_POST["TBLPREFIX"]."privacy"]["p_priv_hide"]["details"] = "INT (3)";
$db_original["".$_POST["TBLPREFIX"]."privacy"]["p_priv_public"]["details"] = "INT (3)";
$db_original["".$_POST["TBLPREFIX"]."privacy"]["p_priv_user"]["details"] = "INT (3)";
$db_original["".$_POST["TBLPREFIX"]."privacy"]["p_priv_none"]["details"] = "INT (3)";
$db_original["".$_POST["TBLPREFIX"]."privacy"]["p_show_dead_people"]["details"] = "VARCHAR (12)";
$db_original["".$_POST["TBLPREFIX"]."privacy"]["p_show_living_names"]["details"] = "VARCHAR (12)";
$db_original["".$_POST["TBLPREFIX"]."privacy"]["p_show_sources"]["details"] = "VARCHAR (12)";
$db_original["".$_POST["TBLPREFIX"]."privacy"]["p_max_alive_age"]["details"] = "INT (4)";
$db_original["".$_POST["TBLPREFIX"]."privacy"]["p_show_research_log"]["details"] = "VARCHAR (12)";
$db_original["".$_POST["TBLPREFIX"]."privacy"]["p_enable_clippings_cart"]["details"] = "VARCHAR (12)";
$db_original["".$_POST["TBLPREFIX"]."privacy"]["p_use_relationship_privacy"]["details"] = "TINYINT(1)";
$db_original["".$_POST["TBLPREFIX"]."privacy"]["p_max_relation_path_length"]["details"] = "INT (3)";
$db_original["".$_POST["TBLPREFIX"]."privacy"]["p_check_marriage_relations"]["details"] = "TINYINT(1)";
$db_original["".$_POST["TBLPREFIX"]."privacy"]["p_privacy_by_year"]["details"] = "TINYINT(1)";
$db_original["".$_POST["TBLPREFIX"]."privacy"]["p_privacy_by_resn"]["details"] = "TINYINT(1)";
$db_original["".$_POST["TBLPREFIX"]."privacy"]["p_person_privacy"]["details"] = "TEXT";
$db_original["".$_POST["TBLPREFIX"]."privacy"]["p_user_privacy"]["details"] = "TEXT";
$db_original["".$_POST["TBLPREFIX"]."privacy"]["p_global_facts"]["details"] = "TEXT";
$db_original["".$_POST["TBLPREFIX"]."privacy"]["p_person_facts"]["details"] = "TEXT";

$db_original["".$_POST["TBLPREFIX"]."sources"]["s_id"]["details"] = "VARCHAR(255)";
$db_original["".$_POST["TBLPREFIX"]."sources"]["s_file"]["details"] = "TEXT";
$db_original["".$_POST["TBLPREFIX"]."sources"]["s_name"]["details"] = "TEXT";
$db_original["".$_POST["TBLPREFIX"]."sources"]["s_gedcom"]["details"] = "TEXT";

$db_original["".$_POST["TBLPREFIX"]."statscache"]["gs_gedcom"]["details"] = "VARCHAR(64) NOT NULL";
$db_original["".$_POST["TBLPREFIX"]."statscache"]["gs_title"]["details"] = "VARCHAR(255) NOT NULL DEFAULT ''";
$db_original["".$_POST["TBLPREFIX"]."statscache"]["gs_nr_surnames"]["details"] = "INT(11) NOT NULL DEFAULT '0'";
$db_original["".$_POST["TBLPREFIX"]."statscache"]["gs_nr_fams"]["details"] = "INT(11) NOT NULL DEFAULT '0'";
$db_original["".$_POST["TBLPREFIX"]."statscache"]["gs_nr_sources"]["details"] = "INT(11) NOT NULL DEFAULT '0'";
$db_original["".$_POST["TBLPREFIX"]."statscache"]["gs_nr_other"]["details"] = "INT(11) NOT NULL DEFAULT '0'";
$db_original["".$_POST["TBLPREFIX"]."statscache"]["gs_nr_events"]["details"] = "INT(11) NOT NULL DEFAULT '0'";
$db_original["".$_POST["TBLPREFIX"]."statscache"]["gs_earliest_birth_year"]["details"] = "INT(5) NOT NULL DEFAULT '0'";
$db_original["".$_POST["TBLPREFIX"]."statscache"]["gs_earliest_birth_gid"]["details"] = "VARCHAR(10) NOT NULL DEFAULT '0'";
$db_original["".$_POST["TBLPREFIX"]."statscache"]["gs_latest_birth_year"]["details"] = "INT(5) NOT NULL DEFAULT '0'";
$db_original["".$_POST["TBLPREFIX"]."statscache"]["gs_latest_birth_gid"]["details"] = "VARCHAR(10) NOT NULL DEFAULT '0'";
$db_original["".$_POST["TBLPREFIX"]."statscache"]["gs_longest_live_years"]["details"] = "INT(5) NOT NULL DEFAULT '0'";
$db_original["".$_POST["TBLPREFIX"]."statscache"]["gs_longest_live_gid"]["details"] = "VARCHAR(10) NOT NULL DEFAULT '0'";
$db_original["".$_POST["TBLPREFIX"]."statscache"]["gs_avg_age"]["details"] = "INT(4) NOT NULL DEFAULT '0'";
$db_original["".$_POST["TBLPREFIX"]."statscache"]["gs_most_children_gid"]["details"] = "VARCHAR(10) NOT NULL DEFAULT '0'";
$db_original["".$_POST["TBLPREFIX"]."statscache"]["gs_most_children_nr"]["details"] = "INT(3) NOT NULL DEFAULT '0'";
$db_original["".$_POST["TBLPREFIX"]."statscache"]["gs_avg_children"]["details"] = "FLOAT NOT NULL DEFAULT '0'";

$db_original["".$_POST["TBLPREFIX"]."users"]["u_username"]["details"] = "VARCHAR(30) BINARY NOT NULL DEFAULT ''";
$db_original["".$_POST["TBLPREFIX"]."users"]["u_password"]["details"] = "VARCHAR(255) DEFAULT NULL";
$db_original["".$_POST["TBLPREFIX"]."users"]["u_firstname"]["details"] = "VARCHAR(255) DEFAULT NULL";
$db_original["".$_POST["TBLPREFIX"]."users"]["u_lastname"]["details"] = "VARCHAR(255) DEFAULT NULL";
$db_original["".$_POST["TBLPREFIX"]."users"]["u_gedcomid"]["details"] = "TEXT";
$db_original["".$_POST["TBLPREFIX"]."users"]["u_rootid"]["details"] = "TEXT";
$db_original["".$_POST["TBLPREFIX"]."users"]["u_canadmin"]["details"] = "CHAR(2) DEFAULT NULL";
$db_original["".$_POST["TBLPREFIX"]."users"]["u_canedit"]["details"] = "TEXT";
$db_original["".$_POST["TBLPREFIX"]."users"]["u_email"]["details"] = "TEXT";
$db_original["".$_POST["TBLPREFIX"]."users"]["u_verified"]["details"] = "VARCHAR(20) DEFAULT NULL";
$db_original["".$_POST["TBLPREFIX"]."users"]["u_verified_by_admin"]["details"] = "VARCHAR(20) DEFAULT NULL";
$db_original["".$_POST["TBLPREFIX"]."users"]["u_language"]["details"] = "VARCHAR(50) DEFAULT NULL";
$db_original["".$_POST["TBLPREFIX"]."users"]["u_pwrequested"]["details"] = "VARCHAR(20) DEFAULT NULL";
$db_original["".$_POST["TBLPREFIX"]."users"]["u_reg_timestamp"]["details"] = "VARCHAR(50) DEFAULT NULL";
$db_original["".$_POST["TBLPREFIX"]."users"]["u_reg_hashcode"]["details"] = "VARCHAR(255) DEFAULT NULL";
$db_original["".$_POST["TBLPREFIX"]."users"]["u_theme"]["details"] = "VARCHAR(50) DEFAULT NULL";
$db_original["".$_POST["TBLPREFIX"]."users"]["u_loggedin"]["details"] = "CHAR(2) DEFAULT NULL";
$db_original["".$_POST["TBLPREFIX"]."users"]["u_sessiontime"]["details"] = "INT(11) DEFAULT NULL";
$db_original["".$_POST["TBLPREFIX"]."users"]["u_contactmethod"]["details"] = "VARCHAR(20) DEFAULT NULL";
$db_original["".$_POST["TBLPREFIX"]."users"]["u_visibleonline"]["details"] = "CHAR(2) DEFAULT NULL";
$db_original["".$_POST["TBLPREFIX"]."users"]["u_editaccount"]["details"] = "CHAR(2) DEFAULT NULL";
$db_original["".$_POST["TBLPREFIX"]."users"]["u_defaulttab"]["details"] = "INT(11) DEFAULT NULL";
$db_original["".$_POST["TBLPREFIX"]."users"]["u_comment"]["details"] = "VARCHAR(255) DEFAULT NULL";
$db_original["".$_POST["TBLPREFIX"]."users"]["u_comment_exp"]["details"] = "VARCHAR(20) DEFAULT NULL";
$db_original["".$_POST["TBLPREFIX"]."users"]["u_sync_gedcom"]["details"] = "CHAR(2) DEFAULT NULL";
$db_original["".$_POST["TBLPREFIX"]."users"]["u_relationship_privacy"]["details"] = "CHAR(2) DEFAULT NULL";
$db_original["".$_POST["TBLPREFIX"]."users"]["u_max_relation_path"]["details"] = "INT(11) DEFAULT NULL";
$db_original["".$_POST["TBLPREFIX"]."users"]["u_auto_accept"]["details"] = "CHAR(2) DEFAULT NULL";
ksort($db_original);
?>
